﻿CREATE TABLE [dbo].[Account]
(
	[AccountID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [dbo_Account_AccountID] PRIMARY KEY,
    [CommentKarma] INT NOT NULL CONSTRAINT [dbo_Account_CommentKarma] DEFAULT (0), 
    [Created] DATETIME NOT NULL CONSTRAINT [dbo_Account_Created] DEFAULT GETDATE(), 
    [CreatedUTC] DATETIME NOT NULL CONSTRAINT [dbo_Account_CreatedUTC] DEFAULT GETDATE(), 
    [HasMail] BIT NOT NULL CONSTRAINT [dbo_Account_HasMail] DEFAULT ('False'), 
    [HasModMail] BIT NOT NULL CONSTRAINT [dbo_Account_HasModMail] DEFAULT ('False'), 
    [HasVerifiedMail] BIT NOT NULL CONSTRAINT [dbo_Account_HasVerifiedMail] DEFAULT ('False'), 
    [ID] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Account_ID] UNIQUE, 
    [IsFriend] BIT NOT NULL CONSTRAINT [dbo_Account_IsFriend] DEFAULT ('False'), 
    [IsGold] BIT NOT NULL CONSTRAINT [dbo_Account_IsGold] DEFAULT ('False'), 
    [IsMod] BIT NOT NULL CONSTRAINT [dbo_Account_IsMod] DEFAULT ('False'), 
    [LinkKarma] INT NOT NULL CONSTRAINT [dbo_Account_LK] DEFAULT (0), 
    [Modhash] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Account_ModHash] DEFAULT ('NONE'), 
    [Name] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Account_Name] UNIQUE, 
    [Over18] BIT NOT NULL CONSTRAINT [dbo_Account_Over18] DEFAULT ('False')
)
